CREATE TABLE [dbo].[PledgeReport]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_ID] DEFAULT (''),
[TransactionType] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_TransactionType] DEFAULT (''),
[TransactionNumber] [int] NOT NULL CONSTRAINT [DF_PledgeReport_TransactionNumber] DEFAULT ((0)),
[InvoiceReferenceNumber] [int] NOT NULL CONSTRAINT [DF_PledgeReport_InvoiceReferenceNumber] DEFAULT ((0)),
[TransactionDate] [datetime] NULL,
[DateReceived] [datetime] NULL,
[FiscalYear] [int] NOT NULL CONSTRAINT [DF_PledgeReport_FiscalYear] DEFAULT ((0)),
[FiscalMonth] [int] NOT NULL CONSTRAINT [DF_PledgeReport_FiscalMonth] DEFAULT ((0)),
[AppealCode] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_AppealCode] DEFAULT (''),
[CampaignCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_CampaignCode] DEFAULT (''),
[Fund] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_Fund] DEFAULT (''),
[SolicitorID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_SolicitorID] DEFAULT (''),
[SourceSystem] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_SourceSystem] DEFAULT (''),
[MatchingTransaction] [int] NOT NULL CONSTRAINT [DF_PledgeReport_MatchingTransaction] DEFAULT ((0)),
[IsMatchingGift] [tinyint] NOT NULL CONSTRAINT [DF_PledgeReport_IsMatchingGift] DEFAULT ((0)),
[MemorialID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_MemorialID] DEFAULT (''),
[ListAs] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_ListAs] DEFAULT (''),
[RequestNumber] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_PledgeReport_RequestNumber] DEFAULT ((0)),
[InstallmentDate] [datetime] NULL,
[LastPaymentDate] [datetime] NULL,
[PledgeAmount] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_PledgeReport_PledgeAmount] DEFAULT ((0)),
[AdjustmentsAmount] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_PledgeReport_AdjustmentsAmount] DEFAULT ((0)),
[PaymentsAmount] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_PledgeReport_PaymentsAmount] DEFAULT ((0)),
[PledgeFairMarketValue] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_PledgeReport_PledgeFairMarketValue] DEFAULT ((0)),
[MemorialNameText] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PledgeReport_MemorialNameText] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iPledgeReportIDTransactionDate] ON [dbo].[PledgeReport] ([ID], [TransactionDate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iPledgeReportTransactionDate] ON [dbo].[PledgeReport] ([TransactionDate]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iPledgeReportTransactionNumber] ON [dbo].[PledgeReport] ([TransactionNumber]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[PledgeReport] TO [IMIS]
GRANT SELECT ON  [dbo].[PledgeReport] TO [IMIS]
GRANT INSERT ON  [dbo].[PledgeReport] TO [IMIS]
GRANT DELETE ON  [dbo].[PledgeReport] TO [IMIS]
GRANT UPDATE ON  [dbo].[PledgeReport] TO [IMIS]
GO